USE Insults

SELECT i.insult as 'Find an insult that is 8 words long'  
FROM Insults i
WHERE i.NumberOfWords = 8

GO 

SELECT i.insult as 'Find an insult with a burn level greater than 9.5'  
FROM Insults i
WHERE i.burnLevel > 9.5

GO 

SELECT i.insult as 'Find an insult about someones who is skinny'  
FROM Insults i
WHERE i.Flaw = 'skinny'

GO 
SELECT i.insult as 'Find an insult for a whole group'  
FROM Insults i
WHERE i.Target = 'group'

GO 
SELECT i.insult as 'Find an insult for someones mama where the burn level is greater than 8'  
FROM Insults i
WHERE i.burnLevel > 8
  AND i.Target = 'mama'

GO 
SELECT i.insult as 'Find an insult for a friend that is annoying'  
FROM Insults i
WHERE i.Flaw = 'annoying'
  AND i.Target = 'friend'

GO 

SELECT i.insult as 'Find an fat insult not about your mama'  
FROM Insults i
WHERE i.Flaw = 'fat'
  AND i.Target <> 'mama'

GO 


SELECT i.insult as 'Find an insult for a brother or dad'  
FROM Insults i
WHERE i.Target = 'brother' or i.Target = 'dad'

GO 

SELECT i.insult as 'Find an insult With a Burn Level Rating between 8.5 and 9'  
FROM Insults i
WHERE 8.5 < i.BurnLevel  AND i.BurnLevel < 9.0
GO 

SELECT i.insult as 'Find an insult that starts with the word monkey'  
FROM Insults i
WHERE i.insult LIKE 'Monkey%'
GO 

SELECT i.insult as 'Find an insult that ends with the word inflatable'  
FROM Insults i
WHERE i.insult LIKE '%inflatable'
GO 

SELECT i.insult as 'Find an insult has the word horse'  
FROM Insults i
WHERE i.insult LIKE '%horse%'
GO 

SELECT Count(*) as 'Find how many insults there are for annoying people'  
FROM Insults i
WHERE i.Flaw = 'annoying'
GO 


SELECT AVG(i.BurnLevel) as 'Find the average burn level for your mama jokes'  
FROM Insults i
WHERE i.Target = 'mama'
GO 

SELECT i.insult as 'Show the stupid jokes in order of number of words'  
FROM Insults i
WHERE i.Flaw = 'stupid'
ORDER BY i.NumberOfWords
GO 

